package org.javagril.yuetong.mapper;

import org.apache.ibatis.annotations.Param;
import org.javagril.yuetong.bean.Carriers;

import java.util.List;

public interface CarriersMapper {
    int deleteByPrimaryKey(Integer carriersid);

    int insert(Carriers record);

    int insertSelective(Carriers record);

    Carriers selectByPrimaryKey(Integer carriersid);

    int updateByPrimaryKeySelective(Carriers record);

    int updateByPrimaryKey(Carriers record);

    /*查询所有*/
    List<Carriers> getAllCarriers(@Param("page") Integer page, @Param("size") Integer size);

    /*数据总条数*/
    Long getTotal();

    /*结合调度员 查询未分配的信息*/
    List<Carriers> getCarriersByState(@Param("state") Integer state, @Param("page") Integer page, @Param("size") Integer size);

    /*结合调度员 查询未分配的信息*/
    Long getTotalByState(Integer state);


}